home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 17 / Developer Source Volume 17 (I-MODE Publications, Inc.)(2000).iso / orinf / mar97 / hipsf102.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  21.7 KB  |  333x320  |  4-bit (16 colors)
   ocr: Oracle Mocedure Builder Ele Edit Tools Window Belp Stored Prograi Unit - SCOTT.ANNUAL SAL. UPDAIE Now Sayeli Hevist Diop. Lioze Owne SCOTT Name ANNUAL SAL UPDATE (Prod2 PROCEDURE annual sal update IS emp_NUA number; new_sal number; cursor neu - salaries is select enpno, sal_increase(empno) From enpi BEGIN open new_s salaries; loop Fetch neu salaries into emp_ num, new_sal; if neu salariesZNUTFOUND then exit; end if; update enp set sal a new_sal here enpno - emp. num; end loap; close new_ salaries; END; NolModied UCG - - - compled Figure 2: A procedure that updates employee salaries.